The Replenishment Item Quantity table is used to store a snapshot of the current stock situation of the items in the stores and warehouses. This table is usually calculated once per day in a nightly Scheduler Job run and is the basis for the calculation of the Replenishment Journals.
If the Out of Stock days should be considered in the Replenishment Item Quantity calculation, the Out of Stock table needs to be calculated upfront.
The below process describes how the Replenishment Item Quantity table is created or updated - for a more detailed description of the fields in the table, see Replenishment Item Quantity.
There are four methods of calculating the table:
1. Calculation for a single Item
It is possible to calculate the Replenishment Item Quantity records for a specific Item by calling the function Recalculate Quantity for Item on the Replen. Item Quantities page. You can access this page by opening the Item page and then opening the Replenishment Control Data page.
The Replenishment Item Quantity data can be accessed via the Location Quantities action or via the Replenishment FactBox.
2. Manual calculation for a set of Items
If you want to calculate the Replenishment Item Quantities for set up items, you can use the report Replenishment – Calc. Item Quantities. This report is located in Departments - LS Retail - Replenishment - Automatic.
Note: Be aware that a calculation for all items and stores can be quite time consuming. Always use proper filtering, when calling the report during business hours.
3. Scheduled calculation with LS Scheduler
It is possible to schedule the execution of the Replenishment – Calc. Qtys report by calling the REPLEN-QTY Scheduler Job.
4. Calculation from Replen. Journals
It is possible to run the Replenishment Item Quantity calculation as part of adding lines to the Replenishment Journal Lines. The system will run the Replenishment – Calc. Item Quantities report as when running it directly in the Periodic Activities folder.
When calling the report Add Items to Journal from the Replenishment Journals page, you have the option to calculate the Replenishment Item Quantities when you select the field Calculate Inventory.
Note: This field is available in the Replenishment Journal and Redistribution Journal pages.
See Also
Replenishment Item Quantity table